Overview
Brought to you by YData
Dataset statistics
| Number of variables | 13 |
|---|---|
| Number of observations | 52416 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 4.6 MiB |
| Average record size in memory | 92.0 B |
Variable types
| Numeric | 12 |
|---|---|
| Categorical | 1 |
Year has constant value "2017" | Constant |
DiffuseFlows is highly overall correlated with GeneralDiffuseFlows | High correlation |
GeneralDiffuseFlows is highly overall correlated with DiffuseFlows | High correlation |
Hour is highly overall correlated with PowerConsumption_Zone1 and 1 other fields | High correlation |
PowerConsumption_Zone1 is highly overall correlated with Hour and 2 other fields | High correlation |
PowerConsumption_Zone2 is highly overall correlated with Hour and 2 other fields | High correlation |
PowerConsumption_Zone3 is highly overall correlated with PowerConsumption_Zone1 and 1 other fields | High correlation |
Hour has 2184 (4.2%) zeros | Zeros |
Minute has 8736 (16.7%) zeros | Zeros |
Reproduction
| Analysis started | 2025-01-19 05:09:03.715467 |
|---|---|
| Analysis finished | 2025-01-19 05:09:43.779854 |
| Duration | 40.06 seconds |
| Software version | ydata-profiling vv4.12.1 |
| Download configuration | config.json |
Variables
Temperature
Real number (ℝ)
| Distinct | 3437 |
|---|---|
| Distinct (%) | 6.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 18.810024 |
| Minimum | 3.247 |
|---|---|
| Maximum | 40.01 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 819.0 KiB |
Quantile statistics
| Minimum | 3.247 |
|---|---|
| 5-th percentile | 9.8 |
| Q1 | 14.41 |
| median | 18.78 |
| Q3 | 22.89 |
| 95-th percentile | 28.39 |
| Maximum | 40.01 |
| Range | 36.763 |
| Interquartile range (IQR) | 8.48 |
Descriptive statistics
| Standard deviation | 5.8154758 |
|---|---|
| Coefficient of variation (CV) | 0.30916898 |
| Kurtosis | -0.30332122 |
| Mean | 18.810024 |
| Median Absolute Deviation (MAD) | 4.26 |
| Skewness | 0.19671914 |
| Sum | 985946.22 |
| Variance | 33.819759 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 15.18 | 58 | 0.1% |
| 20.76 | 56 | 0.1% |
| 19.79 | 55 | 0.1% |
| 20.74 | 52 | 0.1% |
| 20.83 | 51 | 0.1% |
| 15.85 | 51 | 0.1% |
| 15.84 | 51 | 0.1% |
| 21 | 50 | 0.1% |
| 20.89 | 50 | 0.1% |
| 20.37 | 49 | 0.1% |
| Other values (3427) | 51893 |
| Value | Count | Frequency (%) |
| 3.247 | 1 | |
| 3.441 | 1 | |
| 3.541 | 1 | |
| 3.555 | 1 | |
| 3.582 | 1 | |
| 3.629 | 1 | |
| 3.638 | 1 | |
| 3.662 | 1 | |
| 3.681 | 1 | |
| 3.706 | 1 |
| Value | Count | Frequency (%) |
| 40.01 | 1 | |
| 39.78 | 1 | |
| 39.76 | 1 | |
| 39.74 | 1 | |
| 39.73 | 1 | |
| 39.7 | 1 | |
| 39.67 | 1 | |
| 39.6 | 1 | |
| 39.59 | 1 | |
| 39.55 | 1 |
Humidity
Real number (ℝ)
| Distinct | 4443 |
|---|---|
| Distinct (%) | 8.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 68.259518 |
| Minimum | 11.34 |
|---|---|
| Maximum | 94.8 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 819.0 KiB |
Quantile statistics
| Minimum | 11.34 |
|---|---|
| 5-th percentile | 39.45 |
| Q1 | 58.31 |
| median | 69.86 |
| Q3 | 81.4 |
| 95-th percentile | 88.9 |
| Maximum | 94.8 |
| Range | 83.46 |
| Interquartile range (IQR) | 23.09 |
Descriptive statistics
| Standard deviation | 15.551177 |
|---|---|
| Coefficient of variation (CV) | 0.2278243 |
| Kurtosis | -0.12185965 |
| Mean | 68.259518 |
| Median Absolute Deviation (MAD) | 11.54 |
| Skewness | -0.62516601 |
| Sum | 3577890.9 |
| Variance | 241.83911 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 85.9 | 197 | 0.4% |
| 84.6 | 190 | 0.4% |
| 85 | 189 | 0.4% |
| 86.6 | 187 | 0.4% |
| 86.3 | 186 | 0.4% |
| 85.8 | 185 | 0.4% |
| 87.2 | 175 | 0.3% |
| 86.8 | 173 | 0.3% |
| 87.4 | 171 | 0.3% |
| 86.9 | 171 | 0.3% |
| Other values (4433) | 50592 |
| Value | Count | Frequency (%) |
| 11.34 | 2 | |
| 11.57 | 1 | |
| 11.94 | 1 | |
| 12.27 | 1 | |
| 12.3 | 1 | |
| 12.6 | 1 | |
| 12.74 | 1 | |
| 12.87 | 1 | |
| 13.04 | 1 | |
| 13.07 | 1 |
| Value | Count | Frequency (%) |
| 94.8 | 3 | < 0.1% |
| 94.7 | 4 | < 0.1% |
| 94.6 | 1 | < 0.1% |
| 94.5 | 2 | < 0.1% |
| 94.4 | 1 | < 0.1% |
| 94.3 | 2 | < 0.1% |
| 94.2 | 4 | < 0.1% |
| 94.1 | 6 | |
| 94 | 9 | |
| 93.9 | 10 |
WindSpeed
Real number (ℝ)
| Distinct | 548 |
|---|---|
| Distinct (%) | 1.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.9594889 |
| Minimum | 0.05 |
|---|---|
| Maximum | 6.483 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 819.0 KiB |
Quantile statistics
| Minimum | 0.05 |
|---|---|
| 5-th percentile | 0.069 |
| Q1 | 0.078 |
| median | 0.086 |
| Q3 | 4.915 |
| 95-th percentile | 4.923 |
| Maximum | 6.483 |
| Range | 6.433 |
| Interquartile range (IQR) | 4.837 |
Descriptive statistics
| Standard deviation | 2.348862 |
|---|---|
| Coefficient of variation (CV) | 1.1987116 |
| Kurtosis | -1.7831692 |
| Mean | 1.9594889 |
| Median Absolute Deviation (MAD) | 0.016 |
| Skewness | 0.46242332 |
| Sum | 102708.57 |
| Variance | 5.5171525 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0.082 | 2291 | 4.4% |
| 0.083 | 1979 | 3.8% |
| 0.084 | 1831 | 3.5% |
| 0.081 | 1804 | 3.4% |
| 0.085 | 1513 | 2.9% |
| 0.08 | 1502 | 2.9% |
| 0.073 | 1485 | 2.8% |
| 4.919 | 1430 | 2.7% |
| 4.916 | 1375 | 2.6% |
| 0.072 | 1369 | 2.6% |
| Other values (538) | 35837 |
| Value | Count | Frequency (%) |
| 0.05 | 1 | < 0.1% |
| 0.053 | 5 | < 0.1% |
| 0.054 | 10 | |
| 0.055 | 13 | |
| 0.056 | 9 | |
| 0.057 | 17 | |
| 0.058 | 4 | < 0.1% |
| 0.059 | 7 | |
| 0.06 | 9 | |
| 0.061 | 11 |
| Value | Count | Frequency (%) |
| 6.483 | 1 | |
| 6.325 | 1 | |
| 6.2 | 1 | |
| 5.817 | 1 | |
| 5.69 | 1 | |
| 5.402 | 1 | |
| 5.375 | 1 | |
| 5.044 | 1 | |
| 5.019 | 1 | |
| 5.014 | 2 |
GeneralDiffuseFlows
Real number (ℝ)
High correlation 
| Distinct | 10504 |
|---|---|
| Distinct (%) | 20.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 182.69661 |
| Minimum | 0.004 |
|---|---|
| Maximum | 1163 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 819.0 KiB |
Quantile statistics
| Minimum | 0.004 |
|---|---|
| 5-th percentile | 0.037 |
| Q1 | 0.062 |
| median | 5.0355 |
| Q3 | 319.6 |
| 95-th percentile | 782 |
| Maximum | 1163 |
| Range | 1162.996 |
| Interquartile range (IQR) | 319.538 |
Descriptive statistics
| Standard deviation | 264.40096 |
|---|---|
| Coefficient of variation (CV) | 1.4472132 |
| Kurtosis | 0.40276752 |
| Mean | 182.69661 |
| Median Absolute Deviation (MAD) | 5.0095 |
| Skewness | 1.3069729 |
| Sum | 9576225.7 |
| Variance | 69907.867 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0.055 | 1576 | 3.0% |
| 0.062 | 1557 | 3.0% |
| 0.051 | 1497 | 2.9% |
| 0.059 | 1474 | 2.8% |
| 0.066 | 1459 | 2.8% |
| 0.048 | 1388 | 2.6% |
| 0.044 | 1292 | 2.5% |
| 0.073 | 1262 | 2.4% |
| 0.04 | 1125 | 2.1% |
| 0.077 | 1116 | 2.1% |
| Other values (10494) | 38670 |
| Value | Count | Frequency (%) |
| 0.004 | 3 | < 0.1% |
| 0.007 | 9 | < 0.1% |
| 0.011 | 38 | 0.1% |
| 0.015 | 97 | 0.2% |
| 0.018 | 184 | 0.4% |
| 0.022 | 309 | 0.6% |
| 0.026 | 436 | |
| 0.029 | 566 | |
| 0.033 | 699 | |
| 0.037 | 924 |
| Value | Count | Frequency (%) |
| 1163 | 1 | |
| 1122 | 1 | |
| 1102 | 1 | |
| 1099 | 1 | |
| 1082 | 1 | |
| 1069 | 1 | |
| 1055 | 1 | |
| 1051 | 1 | |
| 1050 | 1 | |
| 1044 | 1 |
DiffuseFlows
Real number (ℝ)
High correlation 
| Distinct | 10449 |
|---|---|
| Distinct (%) | 19.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 75.028022 |
| Minimum | 0.011 |
|---|---|
| Maximum | 936 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 819.0 KiB |
Quantile statistics
| Minimum | 0.011 |
|---|---|
| 5-th percentile | 0.085 |
| Q1 | 0.122 |
| median | 4.456 |
| Q3 | 101 |
| 95-th percentile | 331.85 |
| Maximum | 936 |
| Range | 935.989 |
| Interquartile range (IQR) | 100.878 |
Descriptive statistics
| Standard deviation | 124.21095 |
|---|---|
| Coefficient of variation (CV) | 1.6555274 |
| Kurtosis | 7.0029015 |
| Mean | 75.028022 |
| Median Absolute Deviation (MAD) | 4.393 |
| Skewness | 2.4569065 |
| Sum | 3932668.8 |
| Variance | 15428.36 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0.115 | 1260 | 2.4% |
| 0.122 | 1218 | 2.3% |
| 0.119 | 1201 | 2.3% |
| 0.126 | 1150 | 2.2% |
| 0.111 | 1140 | 2.2% |
| 0.13 | 1093 | 2.1% |
| 0.104 | 1085 | 2.1% |
| 0.1 | 963 | 1.8% |
| 0.137 | 926 | 1.8% |
| 0.096 | 915 | 1.7% |
| Other values (10439) | 41465 |
| Value | Count | Frequency (%) |
| 0.011 | 1 | < 0.1% |
| 0.019 | 3 | < 0.1% |
| 0.022 | 2 | < 0.1% |
| 0.026 | 4 | < 0.1% |
| 0.03 | 10 | < 0.1% |
| 0.033 | 18 | < 0.1% |
| 0.037 | 20 | < 0.1% |
| 0.041 | 34 | |
| 0.044 | 53 | |
| 0.048 | 74 |
| Value | Count | Frequency (%) |
| 936 | 1 | |
| 933 | 1 | |
| 922 | 2 | |
| 909 | 1 | |
| 903 | 1 | |
| 897 | 1 | |
| 863 | 1 | |
| 856 | 1 | |
| 855 | 1 | |
| 851 | 1 |
PowerConsumption_Zone1
Real number (ℝ)
High correlation 
| Distinct | 27709 |
|---|---|
| Distinct (%) | 52.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 32344.971 |
| Minimum | 13895.696 |
|---|---|
| Maximum | 52204.395 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 819.0 KiB |
Quantile statistics
| Minimum | 13895.696 |
|---|---|
| 5-th percentile | 21867.342 |
| Q1 | 26310.669 |
| median | 32265.92 |
| Q3 | 37309.018 |
| 95-th percentile | 44712.058 |
| Maximum | 52204.395 |
| Range | 38308.699 |
| Interquartile range (IQR) | 10998.349 |
Descriptive statistics
| Standard deviation | 7130.5626 |
|---|---|
| Coefficient of variation (CV) | 0.22045352 |
| Kurtosis | -0.75405439 |
| Mean | 32344.971 |
| Median Absolute Deviation (MAD) | 5513.8039 |
| Skewness | 0.22886369 |
| Sum | 1.695394 × 109 |
| Variance | 50844922 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 34560 | 30 | 0.1% |
| 23040 | 24 | < 0.1% |
| 28800 | 19 | < 0.1% |
| 25920 | 18 | < 0.1% |
| 23672.42196 | 13 | < 0.1% |
| 35441.31148 | 13 | < 0.1% |
| 21063.34426 | 12 | < 0.1% |
| 21950.76923 | 12 | < 0.1% |
| 31680 | 12 | < 0.1% |
| 22880.68085 | 11 | < 0.1% |
| Other values (27699) | 52252 |
| Value | Count | Frequency (%) |
| 13895.6962 | 1 | |
| 13920 | 1 | |
| 13932.1519 | 1 | |
| 14090.12658 | 1 | |
| 14327.08861 | 1 | |
| 14557.97468 | 1 | |
| 14612.65823 | 1 | |
| 15013.67089 | 1 | |
| 15524.05063 | 1 | |
| 15572.65823 | 1 |
| Value | Count | Frequency (%) |
| 52204.39512 | 1 | |
| 52146.85905 | 1 | |
| 52038.1798 | 1 | |
| 51955.07214 | 1 | |
| 51916.71476 | 1 | |
| 51820.82131 | 1 | |
| 51776.07103 | 1 | |
| 51737.71365 | 1 | |
| 51731.32075 | 1 | |
| 51718.53496 | 1 |
PowerConsumption_Zone2
Real number (ℝ)
High correlation 
| Distinct | 29621 |
|---|---|
| Distinct (%) | 56.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 21042.509 |
| Minimum | 8560.0815 |
|---|---|
| Maximum | 37408.861 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 819.0 KiB |
Quantile statistics
| Minimum | 8560.0815 |
|---|---|
| 5-th percentile | 13284.146 |
| Q1 | 16980.766 |
| median | 20823.168 |
| Q3 | 24713.718 |
| 95-th percentile | 30387.137 |
| Maximum | 37408.861 |
| Range | 28848.779 |
| Interquartile range (IQR) | 7732.9515 |
Descriptive statistics
| Standard deviation | 5201.4659 |
|---|---|
| Coefficient of variation (CV) | 0.24718848 |
| Kurtosis | -0.43739724 |
| Mean | 21042.509 |
| Median Absolute Deviation (MAD) | 3867.0469 |
| Skewness | 0.32887602 |
| Sum | 1.1029642 × 109 |
| Variance | 27055247 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 21600 | 16 | < 0.1% |
| 25200 | 12 | < 0.1% |
| 14148.32827 | 11 | < 0.1% |
| 23400 | 11 | < 0.1% |
| 22800 | 11 | < 0.1% |
| 16158.83576 | 11 | < 0.1% |
| 13732.5228 | 10 | < 0.1% |
| 18000 | 10 | < 0.1% |
| 13539.20973 | 10 | < 0.1% |
| 22962.16216 | 10 | < 0.1% |
| Other values (29611) | 52304 |
| Value | Count | Frequency (%) |
| 8560.081466 | 1 | |
| 8585.743381 | 1 | |
| 8633.401222 | 1 | |
| 8651.731161 | 1 | |
| 8787.372709 | 1 | |
| 8897.352342 | 1 | |
| 8912.016293 | 1 | |
| 9131.97556 | 1 | |
| 9307.942974 | 1 | |
| 9365.944272 | 1 |
| Value | Count | Frequency (%) |
| 37408.86076 | 1 | |
| 36645.56962 | 1 | |
| 36482.78775 | 1 | |
| 36437.17001 | 1 | |
| 36429.56705 | 1 | |
| 36391.55227 | 1 | |
| 36353.53749 | 1 | |
| 36201.47835 | 1 | |
| 36129.25026 | 1 | |
| 36110.24287 | 1 |
PowerConsumption_Zone3
Real number (ℝ)
High correlation 
| Distinct | 22838 |
|---|---|
| Distinct (%) | 43.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 17835.406 |
| Minimum | 5935.1741 |
|---|---|
| Maximum | 47598.326 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 819.0 KiB |
Quantile statistics
| Minimum | 5935.1741 |
|---|---|
| 5-th percentile | 9519.3277 |
| Q1 | 13129.327 |
| median | 16415.117 |
| Q3 | 21624.1 |
| 95-th percentile | 29905.709 |
| Maximum | 47598.326 |
| Range | 41663.152 |
| Interquartile range (IQR) | 8494.7738 |
Descriptive statistics
| Standard deviation | 6622.1651 |
|---|---|
| Coefficient of variation (CV) | 0.3712932 |
| Kurtosis | 1.0863933 |
| Mean | 17835.406 |
| Median Absolute Deviation (MAD) | 3866.1593 |
| Skewness | 1.0238715 |
| Sum | 9.3486065 × 108 |
| Variance | 43853071 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 17280 | 26 | < 0.1% |
| 11520 | 19 | < 0.1% |
| 9600 | 17 | < 0.1% |
| 9450.180072 | 17 | < 0.1% |
| 9588.47539 | 16 | < 0.1% |
| 9173.589436 | 15 | < 0.1% |
| 9795.918367 | 15 | < 0.1% |
| 16366.26506 | 15 | < 0.1% |
| 9617.286915 | 15 | < 0.1% |
| 9329.171669 | 14 | < 0.1% |
| Other values (22828) | 52247 |
| Value | Count | Frequency (%) |
| 5935.17407 | 1 | |
| 6044.657863 | 1 | |
| 6061.944778 | 1 | |
| 6108.043217 | 1 | |
| 6119.567827 | 1 | |
| 6182.953181 | 1 | |
| 6200.240096 | 1 | |
| 6211.764706 | 1 | |
| 6223.289316 | 1 | |
| 6252.10084 | 1 |
| Value | Count | Frequency (%) |
| 47598.32636 | 2 | |
| 47580.25105 | 1 | |
| 47507.94979 | 1 | |
| 47441.67364 | 1 | |
| 47435.64854 | 1 | |
| 47429.62343 | 1 | |
| 47405.52301 | 1 | |
| 47291.04603 | 1 | |
| 47278.99582 | 1 | |
| 47266.94561 | 1 |
Year
Categorical
Constant 
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.4 MiB |
| 2017 |
|---|
Length
| Max length | 4 |
|---|---|
| Median length | 4 |
| Mean length | 4 |
| Min length | 4 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2017 |
|---|---|
| 2nd row | 2017 |
| 3rd row | 2017 |
| 4th row | 2017 |
| 5th row | 2017 |
Common Values
| Value | Count | Frequency (%) |
| 2017 | 52416 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 2017 | 52416 |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 52416 | |
| 0 | 52416 | |
| 1 | 52416 | |
| 7 | 52416 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 209664 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 52416 | |
| 0 | 52416 | |
| 1 | 52416 | |
| 7 | 52416 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 209664 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 2 | 52416 | |
| 0 | 52416 | |
| 1 | 52416 | |
| 7 | 52416 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 209664 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 2 | 52416 | |
| 0 | 52416 | |
| 1 | 52416 | |
| 7 | 52416 |
Month
Real number (ℝ)
| Distinct | 12 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6.510989 |
| Minimum | 1 |
|---|---|
| Maximum | 12 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 614.2 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 4 |
| median | 7 |
| Q3 | 9.25 |
| 95-th percentile | 12 |
| Maximum | 12 |
| Range | 11 |
| Interquartile range (IQR) | 5.25 |
Descriptive statistics
| Standard deviation | 3.440642 |
|---|---|
| Coefficient of variation (CV) | 0.52843615 |
| Kurtosis | -1.2048069 |
| Mean | 6.510989 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | -0.0085027926 |
| Sum | 341280 |
| Variance | 11.838017 |
| Monotonicity | Increasing |
| Value | Count | Frequency (%) |
| 1 | 4464 | |
| 3 | 4464 | |
| 5 | 4464 | |
| 7 | 4464 | |
| 8 | 4464 | |
| 10 | 4464 | |
| 4 | 4320 | |
| 6 | 4320 | |
| 9 | 4320 | |
| 11 | 4320 | |
| Other values (2) | 8352 |
| Value | Count | Frequency (%) |
| 1 | 4464 | |
| 2 | 4032 | |
| 3 | 4464 | |
| 4 | 4320 | |
| 5 | 4464 | |
| 6 | 4320 | |
| 7 | 4464 | |
| 8 | 4464 | |
| 9 | 4320 | |
| 10 | 4464 |
| Value | Count | Frequency (%) |
| 12 | 4320 | |
| 11 | 4320 | |
| 10 | 4464 | |
| 9 | 4320 | |
| 8 | 4464 | |
| 7 | 4464 | |
| 6 | 4320 | |
| 5 | 4464 | |
| 4 | 4320 | |
| 3 | 4464 |
Day
Real number (ℝ)
| Distinct | 31 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 15.678571 |
| Minimum | 1 |
|---|---|
| Maximum | 31 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 614.2 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 8 |
| median | 16 |
| Q3 | 23 |
| 95-th percentile | 29 |
| Maximum | 31 |
| Range | 30 |
| Interquartile range (IQR) | 15 |
Descriptive statistics
| Standard deviation | 8.7718216 |
|---|---|
| Coefficient of variation (CV) | 0.55947837 |
| Kurtosis | -1.193143 |
| Mean | 15.678571 |
| Median Absolute Deviation (MAD) | 8 |
| Skewness | 0.0074418652 |
| Sum | 821808 |
| Variance | 76.944855 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 1728 | 3.3% |
| 2 | 1728 | 3.3% |
| 28 | 1728 | 3.3% |
| 27 | 1728 | 3.3% |
| 26 | 1728 | 3.3% |
| 25 | 1728 | 3.3% |
| 24 | 1728 | 3.3% |
| 23 | 1728 | 3.3% |
| 22 | 1728 | 3.3% |
| 21 | 1728 | 3.3% |
| Other values (21) | 35136 |
| Value | Count | Frequency (%) |
| 1 | 1728 | |
| 2 | 1728 | |
| 3 | 1728 | |
| 4 | 1728 | |
| 5 | 1728 | |
| 6 | 1728 | |
| 7 | 1728 | |
| 8 | 1728 | |
| 9 | 1728 | |
| 10 | 1728 |
| Value | Count | Frequency (%) |
| 31 | 864 | |
| 30 | 1584 | |
| 29 | 1584 | |
| 28 | 1728 | |
| 27 | 1728 | |
| 26 | 1728 | |
| 25 | 1728 | |
| 24 | 1728 | |
| 23 | 1728 | |
| 22 | 1728 |
Hour
Real number (ℝ)
High correlation  Zeros 
| Distinct | 24 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 11.5 |
| Minimum | 0 |
|---|---|
| Maximum | 23 |
| Zeros | 2184 |
| Zeros (%) | 4.2% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 614.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 5.75 |
| median | 11.5 |
| Q3 | 17.25 |
| 95-th percentile | 22 |
| Maximum | 23 |
| Range | 23 |
| Interquartile range (IQR) | 11.5 |
Descriptive statistics
| Standard deviation | 6.9222526 |
|---|---|
| Coefficient of variation (CV) | 0.60193501 |
| Kurtosis | -1.2041743 |
| Mean | 11.5 |
| Median Absolute Deviation (MAD) | 6 |
| Skewness | 0 |
| Sum | 602784 |
| Variance | 47.917581 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 2184 | 4.2% |
| 1 | 2184 | 4.2% |
| 22 | 2184 | 4.2% |
| 21 | 2184 | 4.2% |
| 20 | 2184 | 4.2% |
| 19 | 2184 | 4.2% |
| 18 | 2184 | 4.2% |
| 17 | 2184 | 4.2% |
| 16 | 2184 | 4.2% |
| 15 | 2184 | 4.2% |
| Other values (14) | 30576 |
| Value | Count | Frequency (%) |
| 0 | 2184 | |
| 1 | 2184 | |
| 2 | 2184 | |
| 3 | 2184 | |
| 4 | 2184 | |
| 5 | 2184 | |
| 6 | 2184 | |
| 7 | 2184 | |
| 8 | 2184 | |
| 9 | 2184 |
| Value | Count | Frequency (%) |
| 23 | 2184 | |
| 22 | 2184 | |
| 21 | 2184 | |
| 20 | 2184 | |
| 19 | 2184 | |
| 18 | 2184 | |
| 17 | 2184 | |
| 16 | 2184 | |
| 15 | 2184 | |
| 14 | 2184 |
Minute
Real number (ℝ)
Zeros 
| Distinct | 6 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 25 |
| Minimum | 0 |
|---|---|
| Maximum | 50 |
| Zeros | 8736 |
| Zeros (%) | 16.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 614.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 10 |
| median | 25 |
| Q3 | 40 |
| 95-th percentile | 50 |
| Maximum | 50 |
| Range | 50 |
| Interquartile range (IQR) | 30 |
Descriptive statistics
| Standard deviation | 17.078414 |
|---|---|
| Coefficient of variation (CV) | 0.68313657 |
| Kurtosis | -1.268578 |
| Mean | 25 |
| Median Absolute Deviation (MAD) | 15 |
| Skewness | 0 |
| Sum | 1310400 |
| Variance | 291.67223 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 8736 | |
| 10 | 8736 | |
| 20 | 8736 | |
| 30 | 8736 | |
| 40 | 8736 | |
| 50 | 8736 |
| Value | Count | Frequency (%) |
| 0 | 8736 | |
| 10 | 8736 | |
| 20 | 8736 | |
| 30 | 8736 | |
| 40 | 8736 | |
| 50 | 8736 |
| Value | Count | Frequency (%) |
| 50 | 8736 | |
| 40 | 8736 | |
| 30 | 8736 | |
| 20 | 8736 | |
| 10 | 8736 | |
| 0 | 8736 |
Interactions
Correlations
| Day | DiffuseFlows | GeneralDiffuseFlows | Hour | Humidity | Minute | Month | PowerConsumption_Zone1 | PowerConsumption_Zone2 | PowerConsumption_Zone3 | Temperature | WindSpeed | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Day | 1.000 | -0.016 | 0.006 | 0.000 | -0.047 | 0.000 | 0.004 | 0.026 | 0.052 | -0.020 | 0.013 | 0.175 |
| DiffuseFlows | -0.016 | 1.000 | 0.786 | 0.142 | -0.253 | -0.001 | -0.099 | 0.125 | 0.097 | -0.021 | 0.261 | 0.022 |
| GeneralDiffuseFlows | 0.006 | 0.786 | 1.000 | 0.195 | -0.459 | 0.000 | 0.019 | 0.261 | 0.242 | 0.085 | 0.472 | 0.157 |
| Hour | 0.000 | 0.142 | 0.195 | 1.000 | -0.253 | 0.000 | 0.000 | 0.732 | 0.679 | 0.467 | 0.184 | 0.006 |
| Humidity | -0.047 | -0.253 | -0.459 | -0.253 | 1.000 | 0.001 | -0.011 | -0.300 | -0.309 | -0.212 | -0.378 | -0.181 |
| Minute | 0.000 | -0.001 | 0.000 | 0.000 | 0.001 | 1.000 | 0.000 | 0.000 | -0.000 | -0.000 | -0.000 | 0.007 |
| Month | 0.004 | -0.099 | 0.019 | 0.000 | -0.011 | 0.000 | 1.000 | -0.009 | 0.300 | -0.322 | 0.304 | 0.146 |
| PowerConsumption_Zone1 | 0.026 | 0.125 | 0.261 | 0.732 | -0.300 | 0.000 | -0.009 | 1.000 | 0.851 | 0.748 | 0.433 | 0.107 |
| PowerConsumption_Zone2 | 0.052 | 0.097 | 0.242 | 0.679 | -0.309 | -0.000 | 0.300 | 0.851 | 1.000 | 0.538 | 0.379 | 0.087 |
| PowerConsumption_Zone3 | -0.020 | -0.021 | 0.085 | 0.467 | -0.212 | -0.000 | -0.322 | 0.748 | 0.538 | 1.000 | 0.436 | 0.079 |
| Temperature | 0.013 | 0.261 | 0.472 | 0.184 | -0.378 | -0.000 | 0.304 | 0.433 | 0.379 | 0.436 | 1.000 | 0.326 |
| WindSpeed | 0.175 | 0.022 | 0.157 | 0.006 | -0.181 | 0.007 | 0.146 | 0.107 | 0.087 | 0.079 | 0.326 | 1.000 |
Missing values
Sample
| Temperature | Humidity | WindSpeed | GeneralDiffuseFlows | DiffuseFlows | PowerConsumption_Zone1 | PowerConsumption_Zone2 | PowerConsumption_Zone3 | Year | Month | Day | Hour | Minute | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Datetime | |||||||||||||
| 2017-01-01 00:00:00 | 6.559 | 73.8 | 0.083 | 0.051 | 0.119 | 34055.69620 | 16128.87538 | 20240.96386 | 2017 | 1 | 1 | 0 | 0 |
| 2017-01-01 00:10:00 | 6.414 | 74.5 | 0.083 | 0.070 | 0.085 | 29814.68354 | 19375.07599 | 20131.08434 | 2017 | 1 | 1 | 0 | 10 |
| 2017-01-01 00:20:00 | 6.313 | 74.5 | 0.080 | 0.062 | 0.100 | 29128.10127 | 19006.68693 | 19668.43373 | 2017 | 1 | 1 | 0 | 20 |
| 2017-01-01 00:30:00 | 6.121 | 75.0 | 0.083 | 0.091 | 0.096 | 28228.86076 | 18361.09422 | 18899.27711 | 2017 | 1 | 1 | 0 | 30 |
| 2017-01-01 00:40:00 | 5.921 | 75.7 | 0.081 | 0.048 | 0.085 | 27335.69620 | 17872.34043 | 18442.40964 | 2017 | 1 | 1 | 0 | 40 |
| 2017-01-01 00:50:00 | 5.853 | 76.9 | 0.081 | 0.059 | 0.108 | 26624.81013 | 17416.41337 | 18130.12048 | 2017 | 1 | 1 | 0 | 50 |
| 2017-01-01 01:00:00 | 5.641 | 77.7 | 0.080 | 0.048 | 0.096 | 25998.98734 | 16993.31307 | 17945.06024 | 2017 | 1 | 1 | 1 | 0 |
| 2017-01-01 01:10:00 | 5.496 | 78.2 | 0.085 | 0.055 | 0.093 | 25446.07595 | 16661.39818 | 17459.27711 | 2017 | 1 | 1 | 1 | 10 |
| 2017-01-01 01:20:00 | 5.678 | 78.1 | 0.081 | 0.066 | 0.141 | 24777.72152 | 16227.35562 | 17025.54217 | 2017 | 1 | 1 | 1 | 20 |
| 2017-01-01 01:30:00 | 5.491 | 77.3 | 0.082 | 0.062 | 0.111 | 24279.49367 | 15939.20973 | 16794.21687 | 2017 | 1 | 1 | 1 | 30 |
| Temperature | Humidity | WindSpeed | GeneralDiffuseFlows | DiffuseFlows | PowerConsumption_Zone1 | PowerConsumption_Zone2 | PowerConsumption_Zone3 | Year | Month | Day | Hour | Minute | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Datetime | |||||||||||||
| 2017-12-30 22:20:00 | 7.650 | 70.1 | 0.081 | 0.062 | 0.122 | 34323.95437 | 28676.28107 | 15684.99400 | 2017 | 12 | 30 | 22 | 20 |
| 2017-12-30 22:30:00 | 7.480 | 71.0 | 0.085 | 0.062 | 0.104 | 33776.42586 | 28230.74563 | 15546.69868 | 2017 | 12 | 30 | 22 | 30 |
| 2017-12-30 22:40:00 | 7.390 | 71.2 | 0.079 | 0.066 | 0.100 | 33387.07224 | 27814.66708 | 15396.87875 | 2017 | 12 | 30 | 22 | 40 |
| 2017-12-30 22:50:00 | 7.340 | 71.0 | 0.084 | 0.037 | 0.119 | 32815.20913 | 27564.28352 | 15172.14886 | 2017 | 12 | 30 | 22 | 50 |
| 2017-12-30 23:00:00 | 7.070 | 72.5 | 0.080 | 0.059 | 0.093 | 32158.17490 | 27273.39675 | 14987.75510 | 2017 | 12 | 30 | 23 | 0 |
| 2017-12-30 23:10:00 | 7.010 | 72.4 | 0.080 | 0.040 | 0.096 | 31160.45627 | 26857.31820 | 14780.31212 | 2017 | 12 | 30 | 23 | 10 |
| 2017-12-30 23:20:00 | 6.947 | 72.6 | 0.082 | 0.051 | 0.093 | 30430.41825 | 26124.57809 | 14428.81152 | 2017 | 12 | 30 | 23 | 20 |
| 2017-12-30 23:30:00 | 6.900 | 72.8 | 0.086 | 0.084 | 0.074 | 29590.87452 | 25277.69254 | 13806.48259 | 2017 | 12 | 30 | 23 | 30 |
| 2017-12-30 23:40:00 | 6.758 | 73.0 | 0.080 | 0.066 | 0.089 | 28958.17490 | 24692.23688 | 13512.60504 | 2017 | 12 | 30 | 23 | 40 |
| 2017-12-30 23:50:00 | 6.580 | 74.1 | 0.081 | 0.062 | 0.111 | 28349.80989 | 24055.23167 | 13345.49820 | 2017 | 12 | 30 | 23 | 50 |